package com.sto.stoapp.db.constant;

/**
 * 条码类型表
 * 
 * @author Administrator
 * 
 */
public interface ScanRuleConstant extends StoBaseConstant {
	public static final String KEY = "key";
	public static final String VALUE = "value";
	public static final String TYPE = "type";
	public static final String BACKUP1 = "backup1";
	public static final String PREFIX = "prefix";
	public static final String SUFFIX = "suffix";
	public static final String SCANLENGTH = "scanLength";
	public static final String BARCODECHECK = "barcodeCheck";

	/**
	 * 条码类型表名
	 */
	public static final String SCAN_RULE_TABLE = "scan_rule_table";

	/**
	 * 创建条码类型表
	 */
	public static final String CREATE_SCAN_RULE_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ SCAN_RULE_TABLE
			+ "("
			+ " id TEXT PRIMARY KEY "
			+ ","
			+ KEY
			+ " text"
			+ ","
			+ VALUE
			+ " text"
			+ ","
			+ TYPE
			+ " text"
			+ ","
			+ BACKUP1
			+ " text"
			+ ","
			+ VERSION
			+ " text"
			+ ","
			+ STATUS
			+ " text "
			+ ","
			+ PREFIX
			+ " text"
			+ ","
			+ SUFFIX
			+ " text"
			+ ","
			+ SCANLENGTH
			+ " text"
			+ ","
			+ BARCODECHECK
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";

}
